package com.ldq.imooc.basics.dataOperation;

import java.sql.SQLException;
import java.util.List;

/**
 * @Author : 李道泉
 * @Description :
 * @Date : 2018/5/5 14:54
 * @Modified by :
 */
public class ProcedureTest {

    public static void main(String[] args) {
        ProcedureDao procedureDao = new ProcedureDao();
        try {
            procedureDao.proc_selectAllNoParams();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        List<Goddess> result = null;
        try {
            result = procedureDao.proc_getInfoByParams("本");

            for (int i = 0; i < result.size(); i++) {
                System.out.println(result.get(i).toString());
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        try {
            Integer count = procedureDao.proc_getCount();
            System.out.println("表imooc_goddess共"+count+"条信息");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
